{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d1a9e2a3-f9e9-48d7-a55b-ca38081ad9ac",
   "metadata": {},
   "outputs": [],
   "source": [
    "pip install pandas numpy scikit-learn openpyxl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7a360042-3d25-4318-8770-58ad612c80c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.preprocessing import StandardScaler"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "addf4ab3-dd18-4cf4-b0c4-63e77aff9d0a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel('/Users/gaoziqin/Documents/毕业论文/欧盟.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "1e482031-e101-463c-89d5-23b6c816e1a5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Economic Data    68\n",
      "Unnamed: 1       70\n",
      "Unnamed: 2       70\n",
      "Unnamed: 3        9\n",
      "Unnamed: 4       70\n",
      "                 ..\n",
      "Unnamed: 98      70\n",
      "Unnamed: 99      70\n",
      "Unnamed: 100     70\n",
      "Unnamed: 101     70\n",
      "Unnamed: 102     70\n",
      "Length: 103, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(df.isnull().sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "70d0a104-de60-437c-9119-8deead708086",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('/Users/gaoziqin/Documents/毕业论文/欧盟.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "50dc426f-ef4b-4909-a738-c8cedaf83066",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
